﻿CREATE PROCEDURE [dbo].[proc_Project_TrackRecord_GetItem]
	(
		@Id int
	)
AS
	Select
		Id,
		ProjectId,
		Description,
		DepartmentId,
		(Select d.DName From Department d Where d.Id=Project_TrackRecord.DepartmentId) as DepartmentName,
		(Select e.EName From Employee e Where e.UserName=Project_TrackRecord.UserName) as UserName,
		CreateDate
	From
		Project_TrackRecord
	Where
		Id=@Id
	
	RETURN
